﻿CREATE TABLE [dbo].[Customer_Subjoin_List] (
    [Id]           INT            IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL,
    [CustomerId]   NVARCHAR (50)  NULL,
    [SubjoinId]    INT            NULL,
    [Description]  NVARCHAR (500) NULL,
    [UpName]       NVARCHAR (50)  NULL,
    [UpTime]       DATETIME       NULL,
    [DepartmentId] INT            NULL,
    CONSTRAINT [PK_Customer_Subjoin_List] PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Subjoin_List_CustomerId]
    ON [dbo].[Customer_Subjoin_List]([CustomerId] ASC);


GO
CREATE NONCLUSTERED INDEX [IX_Customer_Subjoin_List_UpName]
    ON [dbo].[Customer_Subjoin_List]([UpName] ASC);

